package com.ht.shop.dao;


import com.ht.shop.pojo.TbOrder;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface OrderListDao {

     @Select("select t1.uid,t1.id,t1.money,t1.`status`,t1.time,t2.detail from tb_order t1 left join tb_address t2 on t1.aid=t2.id where t1.uid = #{uid}")
     List<TbOrder> findAllListById(Long uid) throws Exception;
     @Select("delete from tb_order where id = #{id}")
     void deleteById(String id);
     @Select("select t1.uid,t1.id,t1.money,t1.`status`,t1.time,t2.detail from tb_order t1 left join tb_address t2 on t1.aid=t2.id where t1.status=0")
     List<TbOrder> findAllListById() throws Exception;
}
